Reconciliation File / Payroll + QuickBooks

Payroll was paid.
The books still didn't agree.

Liabilities under review $28K Payroll-related balances requiring support

State activity 3 States Employee or filing activity involved

Contractors 18 Vendor and 1099 status review

Periods reviewed 4 Quarters Filing and ledger alignment

01 / Where the numbers lived

Three systems were telling three slightly different stories.

Payroll itself was functioning. The problem appeared after processing, when payroll reports, accounting entries, tax payments, benefits, contractor records, and bank withdrawals had to agree.

Small differences accumulated because each system was being reviewed independently rather than as one accounting cycle.

Source 01 Payroll Provider Gross wages, taxes, deductions, reimbursements, net pay, employer taxes and payroll reports.

⇄

Source 02 QuickBooks Online Payroll expense, clearing accounts, payroll liabilities, benefits and contractor transactions.

⇄

Source 03 Bank + Tax Records Net-pay withdrawals, tax deposits, payroll fees, benefit payments and filing support.

The central issue: a payroll liability should represent a real unpaid obligation. It should not remain on the balance sheet simply because prior payroll entries and payments were never fully reconciled.

02 / Payroll Register

Start with what payroll says happened.

The payroll register establishes the economic activity for each pay cycle: employee wages, employer taxes, deductions, reimbursements, and net pay.

Those totals become the reference point for evaluating the QuickBooks entries and bank withdrawals.

Payroll Register / Selected Pay Cycle Illustrative figures

Employee Group	Gross Pay	Employee Tax	Benefits / Deductions	Net Pay	Employer Tax	Ledger Review
Operations	$16,840.00	$3,365.18	$912.44	$12,562.38	$1,288.26	Matched
Administration	$9,420.00	$1,884.00	$477.50	$7,058.50	$720.63	Matched
Sales	$7,380.00	$1,443.62	$265.00	$5,671.38	$564.57	Review mapping
Reimbursements	—	—	—	$842.16	—	Expense review

WORKPAPER NOTE / Gross payroll should be reconciled by payroll period before differences are corrected. Posting an adjustment directly to payroll expense can make the ledger balance while leaving the underlying payroll mapping problem unresolved.

03 / Bank Activity

The bank sees withdrawals. Accounting has to explain them.

A single payroll cycle may produce several withdrawals: net pay, federal taxes, state taxes, benefits, retirement contributions, and provider fees.

Recording every withdrawal as “payroll expense” would overstate expense and leave liability accounts unresolved.

Operating Account • 3184 Payroll Related Activity

07/12 ADP PAYROLL

$25,334.42

Net Pay

07/12 ADP FEDERAL TAX

$8,926.44

Liability

07/12 ADP STATE TAX

$2,146.77

Liability

07/12 BENEFITS PROVIDER

$3,884.12

Split Review

07/12 ADP PROCESSING FEE

$164.00

Expense

What the bank shows

Payroll withdrawal $25,334

Federal tax withdrawal $8,926

State tax withdrawal $2,147

Benefits $3,884

→

What QuickBooks needs

Gross wages Expense

Employer payroll tax Expense

Employee withholdings Liability

Benefits / deductions Expense + Liability

04 / Liability Reconciliation

Every balance had to answer one question: who is this money still owed to?

Federal withholding, state payroll taxes, benefit deductions, garnishments, and payroll clearing accounts all carried balances.

Each amount was tied to a filing, provider statement, payment, or documented exception before it was allowed to remain on the balance sheet.

Review Area Ledger Condition External Support Required Review Status

Federal Payroll Tax Old balances carried forward Form 941 + deposits Match quarterly filings and tax deposits to the liability ledger. Correction

State Withholding Multi-state balances State returns Confirm jurisdiction, employee location, deposits and filing periods. Review

Benefits Payable Balance not clearing monthly Provider invoices Separate employer cost from employee deductions and unpaid amounts. Provider

Net Pay Clearing Residual balance Bank settlement Match payroll batches against bank withdrawals and duplicate integrations. Cleared

Payroll Reimbursements Mixed with wage expense Expense support Reclassify valid reimbursements outside of wage expense where appropriate. Reclass

Payroll liabilities requiring reconciliation APPROX. $28,000

05 / Root Cause

There wasn't one bad transaction.

The differences accumulated because the company expanded faster than its payroll accounting structure.

Employee growth, contractor activity, benefits, integrations, and new state filing responsibilities were added over time without one coordinated review of the accounting setup.

Reconciliation Findings

Payroll journal mappings changed over time, causing similar payroll transactions to post to different expense and liability accounts.

Some payroll tax payments were recorded directly to payroll-tax expense instead of reducing liabilities created by payroll.

Benefit deductions were recorded without a consistent monthly process for clearing provider payments.

Contractor vendors were created without complete W-9 and 1099 classification information.

Multi-state payroll activity expanded before registrations, withholding requirements, and filing responsibilities were reviewed together.

06 / Contractor Records

Payroll cleanup did not stop with employees.

The business also maintained contractor relationships that required a separate vendor, W-9, payment-type, and 1099 review.

Eighteen contractor records were evaluated for completeness and year-end reporting status.

Contractor Vendor Review Selected Records

Vendor	Entity Type	W-9	Annual Payments	Payment Method	1099 Review
Contractor A	Individual	Received	$18,420	ACH	READY
Contractor B	LLC	Missing	$9,640	Check	W-9 NEEDED
Contractor C	Corporation?	Received	$22,880	Card / ACH	CLASSIFY
Contractor D	Individual	Received	$6,725	ACH	READY
Contractor E	LLC	Incomplete	$11,940	Check	REVIEW

07 / Recurring Compliance

The fix had to survive the next payroll, quarter, and year-end.

A cleanup that only corrects old balances will eventually fail again if the recurring control process remains unchanged.

Payroll accounting was therefore organized around three review cycles.

Monthly

Reconcile

Tie payroll batches to gross wages, employer taxes, deductions, liabilities, benefits, reimbursements, and bank withdrawals.

Quarterly

Validate

Compare payroll liabilities against federal and state returns, tax deposits, unemployment reports, and quarter-end balances.

Year-End

Document

Validate W-2 totals, contractor classifications, W-9 support, state activity, and unresolved differences before tax forms are issued.

08 / Control Process

The recurring process became more important than the cleanup entry.

The stabilized workflow connected payroll setup, monthly reconciliation, quarterly filing review, and year-end documentation.

01 / Map

Document the system.

Identify payroll-provider accounts, QuickBooks accounts, tax agencies, benefit providers, deductions, clearing accounts, and contractor classifications.

02 / Reconcile

Tie every payroll batch.

Reconcile gross wages, employer tax, employee deductions, net pay, reimbursements, benefits, liabilities, and bank withdrawals.

03 / Validate

Compare to filings.

Review federal and state returns against payroll and the general ledger before quarter-end differences become historical balances.

04 / Document

Maintain support.

Keep employee, contractor, W-9, registration, benefit, filing, and reconciliation support within a repeatable review file.

05 / Close

Carry forward only what is real.

Clear confirmed liabilities and leave open only amounts supported by a legitimate outstanding obligation.

09 / Result

Payroll stopped being a collection of unexplained balances.

Payroll Register Gross wages, employer taxes, deductions, reimbursements and net pay could be tied back to accounting entries by payroll period.

Liabilities Old payroll balances were separated between real obligations, posting errors, duplicate activity and amounts requiring correction.

Multi-State Employee locations and filing activity were reviewed across the three states involved in the payroll process.

18 Contractors Contractor vendor records moved through a W-9, classification, payment-method and 1099 eligibility review.

Four Quarters Filing periods were compared against payroll and ledger activity rather than relying solely on the current balance sheet.

Recurring Monthly, quarterly and year-end review responsibilities were incorporated into one repeatable payroll accounting cycle.

This case study uses modified financial figures and illustrative records to demonstrate payroll reconciliation methodology while protecting confidential company, employee, contractor, and tax information.

QuickBooks / Payroll / Tax Liabilities

If payroll is being processed but QuickBooks still carries balances nobody can explain, the cleanup should start with reconciliation — not a plug entry.

Eight Leaf Financial Services can help review payroll accounting, reconcile liability balances, organize contractor records, and build a recurring process for monthly, quarterly, and year-end reporting.

Discuss your payroll records →